﻿USE [sms]
GO
/****** Object:  Table [dbo].[Role]    Script Date: 01/12/2011 20:26:15 ******/
SET IDENTITY_INSERT [dbo].[Role] ON
INSERT [dbo].[Role] ([RoleID], [RoleName], [RoleValue], [Enabled]) VALUES (1, N'GlobalAdmin', 137370705556, 1)
INSERT [dbo].[Role] ([RoleID], [RoleName], [RoleValue], [Enabled]) VALUES (2, N'GroupAdmin ', 128161214359, 1)
INSERT [dbo].[Role] ([RoleID], [RoleName], [RoleValue], [Enabled]) VALUES (3, N'GroupUser', 53143, 1)
SET IDENTITY_INSERT [dbo].[Role] OFF
/****** Object:  Table [dbo].[Department]    Script Date: 01/12/2011 20:26:15 ******/
SET IDENTITY_INSERT [dbo].[Department] ON
INSERT [dbo].[Department] ([DepartmentID], [DepartmentName], [Priority], [RetryTime], [Limit]) VALUES (1, N'Admin', 1, 3, 500)
INSERT [dbo].[Department] ([DepartmentID], [DepartmentName], [Priority], [RetryTime], [Limit]) VALUES (2, N'Common', 2, 3, 500)
SET IDENTITY_INSERT [dbo].[Department] OFF
/****** Object:  Table [dbo].[User]    Script Date: 01/12/2011 20:26:15 ******/
SET IDENTITY_INSERT [dbo].[User] ON
INSERT [dbo].[User] ([UserID], [CIL], [NameCN], [NameEN], [Email], [IsActive], [DepartmentID], [Mobile]) VALUES (1, N'Admin', N'管理员', N'Admin', N'Admin@admin.com', 1, 1, N'12345678')
INSERT [dbo].[User] ([UserID], [CIL], [NameCN], [NameEN], [Email], [IsActive], [DepartmentID], [Mobile]) VALUES (2, N'Yi G ZHANG', N'管理员', N'Yi G ZHANG', N'Yi G ZHANG@.com', 1, 1, N'124578')
SET IDENTITY_INSERT [dbo].[User] OFF
/****** Object:  Table [dbo].[UserRoleRelation]    Script Date: 01/12/2011 20:26:15 ******/
INSERT [dbo].[UserRoleRelation] ([UserID], [RoleID]) VALUES (2, 2)
/****** Object:  Table [dbo].[Message]    Script Date: 01/12/2011 20:26:15 ******/
/****** Object:  Table [dbo].[Email]    Script Date: 01/12/2011 20:26:15 ******/
/****** Object:  Table [dbo].[SMSTemplate]    Script Date: 01/12/2011 20:26:15 ******/
/****** Object:  Table [dbo].[Contact]    Script Date: 01/12/2011 20:26:15 ******/
/****** Object:  Table [dbo].[Reminder]    Script Date: 01/12/2011 20:26:15 ******/
/****** Object:  Table [dbo].[Number]    Script Date: 01/12/2011 20:26:15 ******/
